Pandas Profiling Report

Dataset info

Number of variables	46
Number of observations	16947
Missing cells	11177 (1.4%)
Duplicate rows	0 (0.0%)
Total size in memory	5.9 MiB
Average record size in memory	368.0 B

Variables types

Numeric	8
Categorical	28
Boolean	4
Date	6
URL	0
Text (Unique)	0
Rejected	0
Unsupported	0

Warnings

`Account_Name` has a high cardinality: 1635 distinct values	Warning
`ASP` has 301 (1.8%) zeros	Zeros
`ASP` has 3209 (18.9%) missing values	Missing
`ASP_(converted)` is highly skewed (γ1 = 80.47407411)	Skewed
`ASP_(converted)` has 300 (1.8%) zeros	Zeros
`ASP_(converted)` has 3209 (18.9%) missing values	Missing
`Billing_Country` has a high cardinality: 80 distinct values	Warning
`Last_Modified_By` has a high cardinality: 55 distinct values	Warning
`Month` has a high cardinality: 53 distinct values	Warning
`Opportunity_Name` has a high cardinality: 9841 distinct values	Warning
`Opportunity_Owner` has a high cardinality: 53 distinct values	Warning
`Price` has a high cardinality: 53 distinct values	Warning
`Product_Family` has a high cardinality: 227 distinct values	Warning
`Product_Name` has a high cardinality: 456 distinct values	Warning
`Quote_Expiry_Date` has 4625 (27.3%) missing values	Missing
`Sales_Contract_No` has a high cardinality: 5267 distinct values	Warning
`Territory` has a high cardinality: 76 distinct values	Warning
`Total_Amount` is highly skewed (γ1 = 42.00442155)	Skewed
`Total_Taxable_Amount` is highly skewed (γ1 = 33.59918963)	Skewed
`Total_Taxable_Amount` has 997 (5.9%) zeros	Zeros
`TRF` has 11971 (70.6%) zeros	Zeros

Account_Created_Date
Date

Distinct count	809
Unique (%)	4.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2013-07-27 00:00:00
Maximum	2018-12-21 00:00:00

Toggle details

Histogram of 'Account_Created_Date' (bins=N)

Account_Name
Categorical

Distinct count	1635
Unique (%)	9.6%
Missing (%)	0.0%
Missing (n)	0

Account_Name_1888	2124
Account_Name_1836	886
Account_Name_25	752
Other values (1632)	13185

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Account_Name_1888	2124	12.5%
Account_Name_1836	886	5.2%
Account_Name_25	752	4.4%
Account_Name_1991	586	3.5%
Account_Name_1642	397	2.3%
Account_Name_1508	355	2.1%
Account_Name_1440	317	1.9%
Account_Name_533	283	1.7%
Account_Name_263	249	1.5%
Account_Name_660	231	1.4%
Other values (1625)	10767	63.5%

Max length	17
Mean length	16.51560748
Min length	14
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Account_Owner
Categorical

Distinct count	48
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

Person_Name_50	3730
Person_Name_13	1328
Person_Name_8	1286
Other values (45)	10603

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Person_Name_50	3730	22.0%
Person_Name_13	1328	7.8%
Person_Name_8	1286	7.6%
Person_Name_43	1241	7.3%
Person_Name_18	1093	6.4%
Person_Name_3	875	5.2%
Person_Name_32	682	4.0%
Person_Name_4	664	3.9%
Person_Name_65	631	3.7%
Person_Name_64	577	3.4%
Other values (38)	4840	28.6%

Max length	14
Mean length	13.80090872
Min length	13
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Account_Type
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Account_Type_2	8832
Account_Type_0	5868
Account_Type_5	1943
Other values (4)	304

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Account_Type_2	8832	52.1%
Account_Type_0	5868	34.6%
Account_Type_5	1943	11.5%
Account_Type_1	165	1.0%
None	112	0.7%
Account_Type_6	17	0.1%
Account_Type_4	10	0.1%

Max length	14
Mean length	13.93391161
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

ASP
Numeric

Distinct count	302
Unique (%)	1.8%
Missing (%)	18.9%
Missing (n)	3209
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.012128279
Minimum	0
Maximum	80
Zeros (%)	1.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0.25
Q1	0.36
Median	0.4
Q3	0.505
95-th percentile	59
Maximum	80
Range	80
Interquartile range	0.145

Descriptive statistics

Standard deviation	18.85835901
Coef of variation	2.689391617
Kurtosis	5.261237009
Mean	7.012128279
MAD	11.7241345
Skewness	2.623799882
Sum	96332.6183
Variance	355.6377046
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.38	801	4.7%
0.4	712	4.2%
0.36	564	3.3%
0.42	510	3.0%
0.39	465	2.7%
0.37	365	2.2%
0	301	1.8%
0.35	295	1.7%
0.34	270	1.6%
0.365	269	1.6%
Other values (291)	9186	54.2%
(Missing)	3209	18.9%

Minimum 5 values

Value	Count	Frequency (%)
0	301	1.8%
1e-05	1	< 0.1%
0.15	53	0.3%
0.16	8	< 0.1%
0.17	114	0.7%

Maximum 5 values

Value	Count	Frequency (%)
80	14	0.1%
78	86	0.5%
77	12	0.1%
76	6	< 0.1%
75	99	0.6%

ASP_(converted)
Numeric

Distinct count	442
Unique (%)	2.6%
Missing (%)	18.9%
Missing (n)	3209
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.4325537043
Minimum	0
Maximum	67
Zeros (%)	1.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0.27
Q1	0.37326
Median	0.41285
Q3	0.47649
95-th percentile	0.63
Maximum	67
Range	67
Interquartile range	0.10323

Descriptive statistics

Standard deviation	0.7586587831
Coef of variation	1.753906568
Kurtosis	6675.953735
Mean	0.4325537043
MAD	0.09218016785
Skewness	80.47407411
Sum	5942.42279
Variance	0.5755631491
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.38	570	3.4%
0.4	497	2.9%
0.36	326	1.9%
0.39	325	1.9%
0	300	1.8%
0.42	294	1.7%
0.40719	234	1.4%
0.42982	230	1.4%
0.47506	216	1.3%
0.45244	214	1.3%
Other values (431)	10532	62.1%
(Missing)	3209	18.9%

Minimum 5 values

Value	Count	Frequency (%)
0	300	1.8%
1e-05	1	< 0.1%
0.00378	1	< 0.1%
0.15	53	0.3%
0.16	8	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
67	1	< 0.1%
57.68578	1	< 0.1%
1.7	1	< 0.1%
1.6	6	< 0.1%
1	2	< 0.1%

ASP_Currency
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

USD	7361
JPY	4522
EUR	4503
Other values (2)	561

Toggle details

Common values
Composition

Value	Count	Frequency (%)
USD	7361	43.4%
JPY	4522	26.7%
EUR	4503	26.6%
AUD	556	3.3%
GBP	5	< 0.1%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

Billing_Country
Categorical

Distinct count	80
Unique (%)	0.5%
Missing (%)	0.0%
Missing (n)	0

Japan	4879
United States	3802
Germany	1979
Other values (77)	6287

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Japan	4879	28.8%
United States	3802	22.4%
Germany	1979	11.7%
Australia	1169	6.9%
India	672	4.0%
Netherlands	563	3.3%
Singapore	432	2.5%
France	396	2.3%
Spain	317	1.9%
Italy	295	1.7%
Other values (70)	2443	14.4%

Max length	42
Mean length	8.187289786
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Brand
Categorical

Distinct count	26
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0

None	15911
Other	607
Brand_9	140
Other values (23)	289

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	15911	93.9%
Other	607	3.6%
Brand_9	140	0.8%
Brand_5	48	0.3%
Brand_24	38	0.2%
Brand_11	34	0.2%
Brand_25	24	0.1%
Brand_10	22	0.1%
Brand_22	20	0.1%
Brand_21	17	0.1%
Other values (16)	86	0.5%

Max length	8
Mean length	4.12409276
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Bureaucratic_Code
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Bureaucratic_Code_4	12587
Bureaucratic_Code_5	3803
Bureaucratic_Code_1	261
Other values (4)	296

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Bureaucratic_Code_4	12587	74.3%
Bureaucratic_Code_5	3803	22.4%
Bureaucratic_Code_1	261	1.5%
Bureaucratic_Code_2	242	1.4%
Bureaucratic_Code_0	51	0.3%
Bureaucratic_Code_3	2	< 0.1%
Bureaucratic_Code_6	1	< 0.1%

Max length	19
Mean length	19
Min length	19
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Bureaucratic_Code_0_Approval
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	8889
1	8058

Toggle details

Value	Count	Frequency (%)
0	8889	52.5%
1	8058	47.5%

Bureaucratic_Code_0_Approved
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

0	11543
1	5404

Toggle details

Value	Count	Frequency (%)
0	11543	68.1%
1	5404	31.9%

Currency
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

None	16052
EUR	475
USD	420

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	16052	94.7%
EUR	475	2.8%
USD	420	2.5%

Max length	4
Mean length	3.947188293
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

Delivery_Quarter
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Q2	4443
Q1	4317
Q4	4144

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Q2	4443	26.2%
Q1	4317	25.5%
Q4	4144	24.5%
Q3	4043	23.9%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Delivery_Terms
Categorical

Distinct count	9
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

Delivery_Terms_4	7712
Delivery_Terms_2	4633
Delivery_Terms_1	2936
Other values (6)	1666

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Delivery_Terms_4	7712	45.5%
Delivery_Terms_2	4633	27.3%
Delivery_Terms_1	2936	17.3%
Delivery_Terms_6	781	4.6%
Delivery_Terms_5	636	3.8%
Delivery_Terms_8	164	1.0%
Delivery_Terms_3	41	0.2%
Delivery_Terms_7	38	0.2%
Delivery_Terms_0	6	< 0.1%

Max length	16
Mean length	16
Min length	16
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Delivery_Year
Numeric

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2017.137428
Minimum	2016
Maximum	2020
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2016
5-th percentile	2016
Q1	2016
Median	2017
Q3	2018
95-th percentile	2018
Maximum	2020
Range	4
Interquartile range	2

Descriptive statistics

Standard deviation	0.8296028156
Coef of variation	0.0004112772902
Kurtosis	-0.9481673267
Mean	2017.137428
MAD	0.6892043121
Skewness	0.03065373257
Sum	34184428
Variance	0.6882408316
Memory size	132.5 KiB

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
2017	6318	37.3%
2018	5830	34.4%
2016	4371	25.8%
2019	414	2.4%
2020	14	0.1%

Minimum 5 values

Value	Count	Frequency (%)
2016	4371	25.8%
2017	6318	37.3%
2018	5830	34.4%
2019	414	2.4%
2020	14	0.1%

Maximum 5 values

Value	Count	Frequency (%)
2020	14	0.1%
2019	414	2.4%
2018	5830	34.4%
2017	6318	37.3%
2016	4371	25.8%

ID
Numeric

Distinct count	16947
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	17666.65044
Minimum	4854
Maximum	28773
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4854
5-th percentile	6095.3
Q1	11953
Median	18114
Q3	23845.5
95-th percentile	27687.4
Maximum	28773
Range	23919
Interquartile range	11892.5

Descriptive statistics

Standard deviation	6940.859372
Coef of variation	0.3928791933
Kurtosis	-1.172033787
Mean	17666.65044
MAD	5997.31525
Skewness	-0.1785736993
Sum	299396725
Variance	48175528.83
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 4854. 5791. 12402. 16051.5 16533.5 19385.5 20799.5 23849.5 23897.5 28773. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
6141	1	< 0.1%
27384	1	< 0.1%
21263	1	< 0.1%
19212	1	< 0.1%
25353	1	< 0.1%
27400	1	< 0.1%
4871	1	< 0.1%
13059	1	< 0.1%
15106	1	< 0.1%
8961	1	< 0.1%
Other values (16937)	16937	99.9%

Minimum 5 values

Value	Count	Frequency (%)
4854	1	< 0.1%
4856	1	< 0.1%
4858	1	< 0.1%
4859	1	< 0.1%
4860	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
28773	1	< 0.1%
28772	1	< 0.1%
28771	1	< 0.1%
28770	1	< 0.1%
28769	1	< 0.1%

Last_Modified_By
Categorical

Distinct count	55
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

Person_Name_47	8515
Person_Name_50	1210
Person_Name_43	587
Other values (52)	6635

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Person_Name_47	8515	50.2%
Person_Name_50	1210	7.1%
Person_Name_43	587	3.5%
Person_Name_13	578	3.4%
Person_Name_8	511	3.0%
Person_Name_18	438	2.6%
Person_Name_33	429	2.5%
Person_Name_19	395	2.3%
Person_Name_3	395	2.3%
Person_Name_4	315	1.9%
Other values (45)	3574	21.1%

Max length	14
Mean length	13.89809406
Min length	13
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Last_Modified_Date
Date

Distinct count	650
Unique (%)	3.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2015-03-12 00:00:00
Maximum	2018-12-29 00:00:00

Toggle details

Histogram of 'Last_Modified_Date' (bins=N)

Month
Categorical

Distinct count	53
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

2018 - 10	666
2017 - 6	643
2017 - 10	638
Other values (50)	15000

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2018 - 10	666	3.9%
2017 - 6	643	3.8%
2017 - 10	638	3.8%
2016 - 3	628	3.7%
2017 - 7	625	3.7%
2017 - 5	586	3.5%
2018 - 4	579	3.4%
2017 - 12	574	3.4%
2018 - 6	542	3.2%
2018 - 7	536	3.2%
Other values (43)	10930	64.5%

Max length	9
Mean length	8.244527055
Min length	8
Contains chars	False
Contains digits	True
Contains spaces	True
Contains non-words	True

Opportunity_Created_Date
Date

Distinct count	1096
Unique (%)	6.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2013-11-05 00:00:00
Maximum	2018-12-29 00:00:00

Toggle details

Histogram of 'Opportunity_Created_Date' (bins=N)

Opportunity_ID
Numeric

Distinct count	9841
Unique (%)	58.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	5335.940225
Minimum	0
Maximum	12803
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	435.3
Q1	2448.5
Median	5306
Q3	7698
95-th percentile	11203.5
Maximum	12803
Range	12803
Interquartile range	5249.5

Descriptive statistics

Standard deviation	3324.723809
Coef of variation	0.623081157
Kurtosis	-0.7150386945
Mean	5335.940225
MAD	2797.70729
Skewness	0.2852975553
Sum	90428179
Variance	11053788.41
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000e+00 7.50000e+00 1.85000e+01 3.55000e+01 4.45000e+01 ... 1.27095e+04 1.27225e+04 1.27725e+04 1.27815e+04 1.28030e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
12460	36	0.2%
2008	36	0.2%
5123	26	0.2%
6606	26	0.2%
2911	24	0.1%
767	18	0.1%
6654	16	0.1%
8698	16	0.1%
6653	16	0.1%
7568	16	0.1%
Other values (9831)	16717	98.6%

Minimum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
12803	1	< 0.1%
12802	1	< 0.1%
12801	3	< 0.1%
12800	2	< 0.1%
12799	1	< 0.1%

Opportunity_Name
Categorical

Distinct count	9841
Unique (%)	58.1%
Missing (%)	0.0%
Missing (n)	0

Opportunity_Name_5036	36
Opportunity_Name_9795	36
Opportunity_Name_12179	26
Other values (9838)	16849

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Opportunity_Name_5036	36	0.2%
Opportunity_Name_9795	36	0.2%
Opportunity_Name_12179	26	0.2%
Opportunity_Name_11461	26	0.2%
Opportunity_Name_6835	24	0.1%
Opportunity_Name_1661	18	0.1%
Opportunity_Name_9628	16	0.1%
Opportunity_Name_10131	16	0.1%
Opportunity_Name_10944	16	0.1%
Opportunity_Name_10945	16	0.1%
Other values (9831)	16717	98.6%

Max length	22
Mean length	21.15271139
Min length	18
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Opportunity_Owner
Categorical

Distinct count	53
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

Person_Name_50	3781
Person_Name_8	1422
Person_Name_13	1254
Other values (50)	10490

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Person_Name_50	3781	22.3%
Person_Name_8	1422	8.4%
Person_Name_13	1254	7.4%
Person_Name_18	982	5.8%
Person_Name_43	838	4.9%
Person_Name_3	832	4.9%
Person_Name_4	687	4.1%
Person_Name_32	686	4.0%
Person_Name_19	615	3.6%
Person_Name_64	516	3.0%
Other values (43)	5334	31.5%

Max length	14
Mean length	13.8094648
Min length	13
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Opportunity_Type
Categorical

Distinct count	25
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

Opportunity_Type_1	6819
Opportunity_Type_7	5763
Opportunity_Type_19	1900
Other values (22)	2465

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Opportunity_Type_1	6819	40.2%
Opportunity_Type_7	5763	34.0%
Opportunity_Type_19	1900	11.2%
Opportunity_Type_8	1458	8.6%
Opportunity_Type_12	279	1.6%
Opportunity_Type_3	275	1.6%
Opportunity_Type_20	175	1.0%
Opportunity_Type_2	70	0.4%
Opportunity_Type_4	51	0.3%
Opportunity_Type_10	34	0.2%
Other values (15)	123	0.7%

Max length	19
Mean length	18.14539447
Min length	18
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Planned_Delivery_End_Date
Date

Distinct count	1017
Unique (%)	6.0%
Missing (%)	0.4%
Missing (n)	75
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2016-01-05 00:00:00
Maximum	2208-12-31 00:00:00

Toggle details

Histogram of 'Planned_Delivery_End_Date' (bins=N)

Planned_Delivery_Start_Date
Date

Distinct count	986
Unique (%)	5.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2016-01-01 00:00:00
Maximum	2020-09-17 00:00:00

Toggle details

Histogram of 'Planned_Delivery_Start_Date' (bins=N)

Price
Categorical

Distinct count	53
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

None	15982
Other	609
0.24	27
Other values (50)	329

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	15982	94.3%
Other	609	3.6%
0.24	27	0.2%
0.41	22	0.1%
0.28	20	0.1%
0.27	18	0.1%
0.29	17	0.1%
0.32	15	0.1%
0.38	14	0.1%
0.35	14	0.1%
Other values (43)	209	1.2%

Max length	5
Mean length	4.039062961
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

Pricing,_Delivery_Terms_Approved
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

1	9890
0	7057

Toggle details

Value	Count	Frequency (%)
1	9890	58.4%
0	7057	41.6%

Pricing,_Delivery_Terms_Quote_Appr
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

1	13693
0	3254

Toggle details

Value	Count	Frequency (%)
1	13693	80.8%
0	3254	19.2%

Product_Category_B
Categorical

Distinct count	28
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0

None	15928
Other	523
Product_Category_B_2	59
Other values (25)	437

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	15928	94.0%
Other	523	3.1%
Product_Category_B_2	59	0.3%
Product_Category_B_12	51	0.3%
Product_Category_B_7	47	0.3%
Product_Category_B_4	37	0.2%
Product_Category_B_5	36	0.2%
Product_Category_B_17	27	0.2%
Product_Category_B_1	24	0.1%
Product_Category_B_8	23	0.1%
Other values (18)	192	1.1%

Max length	21
Mean length	4.512008025
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Product_Family
Categorical

Distinct count	227
Unique (%)	1.3%
Missing (%)	0.0%
Missing (n)	0

Product_Family_77	1345
Product_Family_133	1249
Product_Family_132	763
Other values (224)	13590

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Product_Family_77	1345	7.9%
Product_Family_133	1249	7.4%
Product_Family_132	763	4.5%
Product_Family_212	636	3.8%
Product_Family_100	619	3.7%
Product_Family_85	596	3.5%
Product_Family_115	540	3.2%
Product_Family_226	524	3.1%
Product_Family_109	499	2.9%
Product_Family_208	478	2.8%
Other values (217)	9698	57.2%

Max length	18
Mean length	17.6441258
Min length	16
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Product_Name
Categorical

Distinct count	456
Unique (%)	2.7%
Missing (%)	0.0%
Missing (n)	0

Product_Name_100	976
Product_Name_226	836
Product_Name_231	579
Other values (453)	14556

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Product_Name_100	976	5.8%
Product_Name_226	836	4.9%
Product_Name_231	579	3.4%
Product_Name_491	524	3.1%
Product_Name_4	474	2.8%
Product_Name_192	442	2.6%
Product_Name_111	388	2.3%
Product_Name_132	383	2.3%
Product_Name_495	350	2.1%
Product_Name_29	345	2.0%
Other values (446)	11650	68.7%

Max length	16
Mean length	15.74609075
Min length	14
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Product_Type
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

None	15935
Other	515
Product_Type_3	179
Other values (4)	318

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	15935	94.0%
Other	515	3.0%
Product_Type_3	179	1.1%
Product_Type_1	142	0.8%
Product_Type_0	94	0.6%
Product_Type_4	73	0.4%
Product_Type_2	9	0.1%

Max length	14
Mean length	4.323656104
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Quote_Expiry_Date
Date

Distinct count	1003
Unique (%)	5.9%
Missing (%)	27.3%
Missing (n)	4625
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2014-09-30 00:00:00
Maximum	2019-06-30 00:00:00

Toggle details

Histogram of 'Quote_Expiry_Date' (bins=N)

Quote_Type
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Non Binding	16777
Binding	170

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Non Binding	16777	99.0%
Binding	170	1.0%

Max length	11
Mean length	10.9598749
Min length	7
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Region
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Japan	4892
EMEA	4664
Americas	3945
Other values (2)	3446

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Japan	4892	28.9%
EMEA	4664	27.5%
Americas	3945	23.3%
APAC	3262	19.2%
Middle East	184	1.1%

Max length	11
Mean length	5.295804567
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Sales_Contract_No
Categorical

Distinct count	5267
Unique (%)	31.1%
Missing (%)	0.0%
Missing (n)	0

None	6973
479	36
108	36
Other values (5264)	9902

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	6973	41.1%
479	36	0.2%
108	36	0.2%
2575	18	0.1%
3878	16	0.1%
3877	16	0.1%
3980	16	0.1%
5583	16	0.1%
3876	16	0.1%
3123	16	0.1%
Other values (5257)	9788	57.8%

Max length	4
Mean length	3.875376173
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Size
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

None	15967
Other	394
Size_3	356
Other values (4)	230

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	15967	94.2%
Other	394	2.3%
Size_3	356	2.1%
Size_4	196	1.2%
Size_1	25	0.1%
Size_0	7	< 0.1%
Size_2	2	< 0.1%

Max length	6
Mean length	4.092405736
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Source_
Categorical

Distinct count	14
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

None	9497
Source_7	2965
Source_9	1459
Other values (11)	3026

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	9497	56.0%
Source_7	2965	17.5%
Source_9	1459	8.6%
Source_11	1421	8.4%
Source_13	786	4.6%
Source_3	418	2.5%
Source_1	137	0.8%
Source_10	106	0.6%
Source_2	86	0.5%
Source_4	43	0.3%
Other values (4)	29	0.2%

Max length	9
Mean length	5.895025668
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Stage
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Closed Won	9533
Closed Lost	7350
Proposal	35
Other values (2)	29

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Closed Won	9533	56.3%
Closed Lost	7350	43.4%
Proposal	35	0.2%
Negotiation	18	0.1%
Qualification	11	0.1%

Max length	13
Mean length	10.43258394
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Territory
Categorical

Distinct count	76
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0

None	4999
Germany	1682
NW America	1568
Other values (73)	8698

Toggle details

Common values
Composition

Value	Count	Frequency (%)
None	4999	29.5%
Germany	1682	9.9%
NW America	1568	9.3%
Australia	1208	7.1%
India	809	4.8%
NE America	760	4.5%
Japan	681	4.0%
Netherlands	533	3.1%
SE America	493	2.9%
France	449	2.6%
Other values (66)	3765	22.2%

Max length	20
Mean length	7.018646368
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Total_Amount
Numeric

Distinct count	8873
Unique (%)	52.4%
Missing (%)	0.3%
Missing (n)	59
Infinite (%)	0.0%
Infinite (n)	0

Mean	1993659.215
Minimum	0
Maximum	1320000000
Zeros (%)	0.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	2900
Q1	26775
Median	107250
Q3	460389.825
95-th percentile	7010372.365
Maximum	1320000000
Range	1320000000
Interquartile range	433614.825

Descriptive statistics

Standard deviation	18484259.88
Coef of variation	9.271524312
Kurtosis	2322.422807
Mean	1993659.215
MAD	3088832.222
Skewness	42.00442155
Sum	3.366891683e+10
Variance	3.416678634e+14
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6200	513	3.0%
4400	461	2.7%
18000	353	2.1%
140000	272	1.6%
1600	204	1.2%
160000	132	0.8%
109620	100	0.6%
23400	80	0.5%
85260	75	0.4%
81200	75	0.4%
Other values (8862)	14623	86.3%

Minimum 5 values

Value	Count	Frequency (%)
0	52	0.3%
0.01	7	< 0.1%
0.02	3	< 0.1%
0.04	1	< 0.1%
0.1	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1320000000	1	< 0.1%
919992410	1	< 0.1%
760000000	1	< 0.1%
660005280	1	< 0.1%
660004620	1	< 0.1%

Total_Taxable_Amount
Numeric

Distinct count	7096
Unique (%)	41.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3224116.789
Minimum	0
Maximum	1356338620
Zeros (%)	5.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	85465.8
Median	376067.25
Q3	1037450
95-th percentile	12770625
Maximum	1356338620
Range	1356338620
Interquartile range	951984.2

Descriptive statistics

Standard deviation	20303604.73
Coef of variation	6.297416022
Kurtosis	1706.197108
Mean	3224116.789
MAD	4753252.673
Skewness	33.59918963
Sum	5.463910723e+10
Variance	4.122363649e+14
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 7.50000000e-02 1.00750000e+02 1.47615000e+02 2.14400000e+03 ... 1.02197399e+08 1.11352244e+08 1.14540404e+08 1.79293831e+08 1.35633862e+09], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	997	5.9%
588325	72	0.4%
109620	68	0.4%
488700	66	0.4%
413700	60	0.4%
552400	60	0.4%
1767640	48	0.3%
523100	40	0.2%
105840	37	0.2%
31053609.6	36	0.2%
Other values (7086)	15463	91.2%

Minimum 5 values

Value	Count	Frequency (%)
0	997	5.9%
0.15	1	< 0.1%
45	1	< 0.1%
100.1	1	< 0.1%
101.4	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1356338620	1	< 0.1%
919992410	1	< 0.1%
760000000	1	< 0.1%
660005280	1	< 0.1%
660004620	1	< 0.1%

Total_Taxable_Amount_Currency
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

USD	7347
JPY	4525
EUR	4518
Other values (2)	557

Toggle details

Common values
Composition

Value	Count	Frequency (%)
USD	7347	43.4%
JPY	4525	26.7%
EUR	4518	26.7%
AUD	553	3.3%
GBP	4	< 0.1%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

TRF
Numeric

Distinct count	101
Unique (%)	0.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.338171948
Minimum	0
Maximum	500
Zeros (%)	70.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	1
95-th percentile	10
Maximum	500
Range	500
Interquartile range	1

Descriptive statistics

Standard deviation	12.16933936
Coef of variation	5.204638339
Kurtosis	468.696877
Mean	2.338171948
MAD	3.674463104
Skewness	17.060823
Sum	39625
Variance	148.0928205
Memory size	132.5 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 60.5 68.5 126.5 187.5 500. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	11971	70.6%
1	2192	12.9%
2	627	3.7%
3	354	2.1%
5	297	1.8%
4	208	1.2%
10	190	1.1%
6	131	0.8%
7	111	0.7%
20	83	0.5%
Other values (91)	783	4.6%

Minimum 5 values

Value	Count	Frequency (%)
0	11971	70.6%
1	2192	12.9%
2	627	3.7%
3	354	2.1%
4	208	1.2%

Maximum 5 values

Value	Count	Frequency (%)
500	1	< 0.1%
429	1	< 0.1%
400	2	< 0.1%
270	1	< 0.1%
250	1	< 0.1%

First rows

	Account_Created_Date	Account_Name	Account_Owner	Account_Type	ASP	ASP_(converted)	ASP_Currency	Billing_Country	Brand	Bureaucratic_Code	Bureaucratic_Code_0_Approval	Bureaucratic_Code_0_Approved	Currency	Delivery_Quarter	Delivery_Terms	Delivery_Year	ID	Last_Modified_By	Last_Modified_Date	Month	Opportunity_Created_Date	Opportunity_ID	Opportunity_Name	Opportunity_Owner	Opportunity_Type	Planned_Delivery_End_Date	Planned_Delivery_Start_Date	Price	Pricing,_Delivery_Terms_Approved	Pricing,_Delivery_Terms_Quote_Appr	Product_Category_B	Product_Family	Product_Name	Product_Type	Quote_Expiry_Date	Quote_Type	Region	Sales_Contract_No	Size	Source_	Stage	Territory	Total_Amount	Total_Taxable_Amount	Total_Taxable_Amount_Currency	TRF
0	2015-06-16	Account_Name_619	Person_Name_51	Account_Type_2	0.52	0.58817	EUR	Netherlands	None	Bureaucratic_Code_4	1	1	None	Q2	Delivery_Terms_2	2016	27761	Person_Name_18	2016-06-13	2016 - 5	2015-12-07	0	Opportunity_Name_12598	Person_Name_18	Opportunity_Type_1	2016-06-30	2016-05-01	None	1	1	None	Product_Family_77	Product_Name_99	None	2016-01-30	Non Binding	EMEA	None	None	None	Closed Lost	None	5272800.0	5272800.0	EUR	10
1	2015-06-16	Account_Name_619	Person_Name_51	Account_Type_2	0.53	0.59948	EUR	Netherlands	None	Bureaucratic_Code_4	0	0	None	Q1	Delivery_Terms_2	2016	27760	Person_Name_20	2016-01-15	2016 - 1	2015-12-07	1	Opportunity_Name_12600	Person_Name_20	Opportunity_Type_1	2016-01-20	2016-01-18	None	0	0	None	Product_Family_77	Product_Name_100	None	2016-01-20	Non Binding	EMEA	39	None	None	Closed Won	None	48230.0	48230.0	EUR	0
2	2015-04-21	Account_Name_1794	Person_Name_64	Account_Type_5	0.48	0.48000	USD	United States	None	Bureaucratic_Code_4	0	0	None	Q1	Delivery_Terms_4	2016	27446	Person_Name_8	2016-09-29	2016 - 1	2015-12-08	2	Opportunity_Name_469	Person_Name_8	Opportunity_Type_1	2016-01-25	2016-01-25	None	0	0	None	Product_Family_81	Product_Name_91	None	2016-09-30	Non Binding	Americas	760	None	Source_7	Closed Won	NW America	83865.6	83865.6	USD	0
3	2013-07-27	Account_Name_1201	Person_Name_8	Account_Type_5	0.53	0.53000	USD	United States	Other	Bureaucratic_Code_5	1	0	USD	Q1	Delivery_Terms_1	2018	16808	Person_Name_8	2018-03-27	2018 - 2	2015-12-08	3	Opportunity_Name_415	Person_Name_8	Opportunity_Type_19	2018-03-31	2018-02-01	0.42	0	1	Product_Category_B_16	Product_Family_209	Product_Name_432	Product_Type_0	NaT	Non Binding	Americas	None	Size_4	Source_11	Closed Lost	NW America	7421881.5	7421881.5	USD	14
4	2013-07-27	Account_Name_1201	Person_Name_8	Account_Type_5	0.53	0.53000	USD	United States	Other	Bureaucratic_Code_5	1	0	USD	Q1	Delivery_Terms_1	2018	16805	Person_Name_8	2018-03-27	2018 - 2	2015-12-08	4	Opportunity_Name_851	Person_Name_8	Opportunity_Type_19	2018-02-28	2018-02-01	0.42	0	1	Product_Category_B_16	Product_Family_209	Product_Name_432	Product_Type_0	2017-06-02	Non Binding	Americas	None	Size_4	Source_11	Closed Lost	NW America	13357192.5	13357192.5	USD	25
5	2013-07-27	Account_Name_1201	Person_Name_8	Account_Type_5	0.53	0.53000	USD	United States	Other	Bureaucratic_Code_5	1	0	USD	Q1	Delivery_Terms_1	2018	16802	Person_Name_8	2018-03-27	2018 - 2	2015-12-08	5	Opportunity_Name_939	Person_Name_8	Opportunity_Type_19	2018-03-31	2018-02-01	0.42	0	1	Product_Category_B_16	Product_Family_209	Product_Name_432	Product_Type_0	2017-06-02	Non Binding	Americas	None	Size_4	Source_11	Closed Lost	NW America	14838277.5	14838277.5	USD	28
6	2013-07-27	Account_Name_1201	Person_Name_8	Account_Type_5	0.38	0.38000	USD	United States	None	Bureaucratic_Code_5	1	0	None	Q1	Delivery_Terms_4	2017	16799	Person_Name_8	2016-10-07	2017 - 2	2015-12-08	6	Opportunity_Name_1618	Person_Name_8	Opportunity_Type_19	2017-05-01	2017-02-01	None	0	1	None	Product_Family_164	Product_Name_308	None	NaT	Non Binding	Americas	None	None	Source_11	Closed Lost	NW America	2659494.6	2659494.6	USD	7
7	2015-04-21	Account_Name_1794	Person_Name_64	Account_Type_5	0.48	0.48000	USD	United States	None	Bureaucratic_Code_4	1	1	None	Q1	Delivery_Terms_4	2016	27455	Person_Name_8	2015-12-09	2016 - 1	2015-12-09	7	Opportunity_Name_8227	Person_Name_8	Opportunity_Type_1	2016-01-25	2016-01-25	None	1	1	None	Product_Family_143	Product_Name_251	None	2016-01-07	Non Binding	Americas	None	None	Source_7	Closed Won	NW America	50688.0	50688.0	USD	0
8	2015-04-20	Account_Name_1888	Person_Name_50	Account_Type_2	NaN	NaN	JPY	Japan	None	Bureaucratic_Code_5	0	0	None	Q1	Delivery_Terms_4	2016	24353	Person_Name_50	2016-04-05	2016 - 2	2015-12-09	8	Opportunity_Name_6151	Person_Name_50	Opportunity_Type_7	2016-02-29	2016-02-29	None	0	1	None	Product_Family_6	Product_Name_6	None	NaT	Non Binding	Japan	None	None	None	Closed Lost	None	15600.0	470400.0	JPY	0
9	2015-04-20	Account_Name_1888	Person_Name_50	Account_Type_2	NaN	NaN	JPY	Japan	None	Bureaucratic_Code_5	0	0	None	Q1	Delivery_Terms_4	2016	24355	Person_Name_50	2016-04-05	2016 - 2	2015-12-09	8	Opportunity_Name_6151	Person_Name_50	Opportunity_Type_7	2016-02-29	2016-02-29	None	0	1	None	Product_Family_4	Product_Name_4	None	NaT	Non Binding	Japan	None	None	None	Closed Lost	None	4400.0	470400.0	JPY	0

Last rows

	Account_Created_Date	Account_Name	Account_Owner	Account_Type	ASP	ASP_(converted)	ASP_Currency	Billing_Country	Brand	Bureaucratic_Code	Bureaucratic_Code_0_Approval	Bureaucratic_Code_0_Approved	Currency	Delivery_Quarter	Delivery_Terms	Delivery_Year	ID	Last_Modified_By	Last_Modified_Date	Month	Opportunity_Created_Date	Opportunity_ID	Opportunity_Name	Opportunity_Owner	Opportunity_Type	Planned_Delivery_End_Date	Planned_Delivery_Start_Date	Price	Pricing,_Delivery_Terms_Approved	Pricing,_Delivery_Terms_Quote_Appr	Product_Category_B	Product_Family	Product_Name	Product_Type	Quote_Expiry_Date	Quote_Type	Region	Sales_Contract_No	Size	Source_	Stage	Territory	Total_Amount	Total_Taxable_Amount	Total_Taxable_Amount_Currency	TRF
16937	2013-07-27	Account_Name_533	Person_Name_13	Account_Type_0	0.5300	0.59948	EUR	Germany	None	Bureaucratic_Code_4	0	0	None	Q1	Delivery_Terms_2	2016	17683	Person_Name_13	2015-12-18	2016 - 2	2015-12-04	12797	Opportunity_Name_4060	Person_Name_13	Opportunity_Type_8	2016-02-29	2016-02-01	None	0	0	None	Product_Family_77	Product_Name_96	None	2016-01-03	Non Binding	EMEA	None	None	Source_9	Closed Won	Germany	413400.00	528918.75	EUR	1
16938	2015-12-04	Account_Name_586	Person_Name_13	Account_Type_2	0.4700	0.53161	EUR	Germany	None	Bureaucratic_Code_5	0	0	None	Q3	Delivery_Terms_2	2016	28767	Person_Name_13	2016-10-21	2016 - 8	2015-12-04	12798	Opportunity_Name_5088	Person_Name_13	Opportunity_Type_19	2016-09-30	2016-08-15	None	0	1	None	Product_Family_85	Product_Name_110	None	2016-02-05	Non Binding	EMEA	None	None	None	Closed Lost	Germany	1307775.00	1307775.00	EUR	3
16939	2013-07-27	Account_Name_533	Person_Name_13	Account_Type_0	0.5150	0.58251	EUR	Germany	None	Bureaucratic_Code_4	0	0	None	Q2	Delivery_Terms_2	2016	18324	Person_Name_13	2016-04-01	2016 - 4	2015-12-04	12799	Opportunity_Name_7202	Person_Name_13	Opportunity_Type_1	2016-04-21	2016-04-01	None	1	1	None	Product_Family_77	Product_Name_96	None	2016-04-03	Non Binding	EMEA	224	None	Source_9	Closed Won	Norway	401700.00	401700.00	EUR	1
16940	2014-06-16	Account_Name_404	Person_Name_13	Account_Type_5	0.5300	0.53000	USD	Germany	None	Bureaucratic_Code_5	0	0	None	Q4	Delivery_Terms_4	2016	20827	Person_Name_13	2016-10-10	2016 - 10	2015-12-04	12800	Opportunity_Name_11979	Person_Name_13	Opportunity_Type_19	2016-12-30	2016-10-03	None	0	1	None	Product_Family_164	Product_Name_307	None	2016-01-15	Non Binding	Americas	None	None	None	Closed Lost	NE America	10751580.00	21332500.00	USD	20
16941	2014-06-16	Account_Name_404	Person_Name_13	Account_Type_5	0.5300	0.53000	USD	Germany	None	Bureaucratic_Code_5	0	0	None	Q4	Delivery_Terms_4	2016	20830	Person_Name_13	2016-10-10	2016 - 10	2015-12-04	12800	Opportunity_Name_11979	Person_Name_13	Opportunity_Type_19	2016-12-30	2016-10-03	None	0	1	None	Product_Family_158	Product_Name_286	None	2016-01-15	Non Binding	Americas	None	None	None	Closed Lost	NE America	10580920.00	21332500.00	USD	20
16942	2016-01-15	Account_Name_726	Person_Name_13	Account_Type_5	0.5200	0.58817	EUR	Austria	None	Bureaucratic_Code_4	1	1	None	Q1	Delivery_Terms_2	2016	8781	Person_Name_13	2016-01-19	2016 - 3	2015-12-04	12801	Opportunity_Name_9245	Person_Name_13	Opportunity_Type_1	2016-03-25	2016-03-21	None	1	1	None	Product_Family_85	Product_Name_111	None	NaT	Non Binding	EMEA	44	None	Source_7	Closed Won	Austria	103350.00	299715.00	EUR	0
16943	2016-01-15	Account_Name_726	Person_Name_13	Account_Type_5	0.5200	0.58817	EUR	Austria	None	Bureaucratic_Code_4	1	1	None	Q2	Delivery_Terms_2	2016	8786	Person_Name_13	2016-01-19	2016 - 4	2015-12-04	12801	Opportunity_Name_9245	Person_Name_13	Opportunity_Type_1	2016-04-08	2016-04-04	None	1	1	None	Product_Family_85	Product_Name_111	None	NaT	Non Binding	EMEA	44	None	Source_7	Closed Won	Austria	93015.00	299715.00	EUR	0
16944	2016-01-15	Account_Name_726	Person_Name_13	Account_Type_5	0.5200	0.58817	EUR	Austria	None	Bureaucratic_Code_4	1	1	None	Q1	Delivery_Terms_2	2016	8792	Person_Name_13	2016-01-19	2016 - 3	2015-12-04	12801	Opportunity_Name_9245	Person_Name_13	Opportunity_Type_1	2016-03-31	2016-03-28	None	1	1	None	Product_Family_85	Product_Name_111	None	NaT	Non Binding	EMEA	44	None	Source_7	Closed Won	Austria	103350.00	299715.00	EUR	0
16945	2015-10-20	Account_Name_944	Person_Name_3	Account_Type_5	0.6375	0.63750	USD	United States	None	Bureaucratic_Code_4	1	1	None	Q2	Delivery_Terms_4	2016	28561	Person_Name_3	2016-01-22	2016 - 4	2015-12-05	12802	Opportunity_Name_5843	Person_Name_3	Opportunity_Type_1	2016-04-29	2016-04-25	None	1	1	None	Product_Family_158	Product_Name_287	None	2016-02-29	Non Binding	Americas	None	None	None	Closed Lost	NE America	2346796.88	0.00	USD	4
16946	2015-09-03	Account_Name_1401	Person_Name_3	Account_Type_5	0.6400	0.64000	USD	United States	None	Bureaucratic_Code_4	1	1	None	Q3	Delivery_Terms_4	2016	28318	Person_Name_3	2016-09-28	2016 - 7	2015-12-05	12803	Opportunity_Name_9911	Person_Name_3	Opportunity_Type_19	2016-08-31	2016-07-01	None	1	1	None	Product_Family_164	Product_Name_307	None	2016-01-06	Non Binding	Americas	None	None	None	Closed Lost	NE America	25603200.00	0.00	USD	40

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows